#Load data files into database table
dir "C:\Example Reports Destination\*.json" | % { [string]$query = "insert into ReportDB.dbo.JSONData (datafile) select x from openrowset (bulk N'$($_)', SINGLE_CLOB) as T(x)"; INVOKE-SQLCMD -SERVER .\HILLVALLEY -Database ReportDB -Query $query -QueryTimeout 3600};

